Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 50 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.9 KiB |
| Average record size in memory | 203.1 B |
Variable types
| Numeric | 15 |
|---|---|
| Categorical | 4 |
| Boolean | 1 |
Unnamed: 0 is highly overall correlated with Artist | High correlation |
Energy is highly overall correlated with Loudness | High correlation |
Loudness is highly overall correlated with Energy | High correlation |
Speechiness is highly overall correlated with Channel | High correlation |
Instrumentalness is highly overall correlated with Channel | High correlation |
Views is highly overall correlated with Likes | High correlation |
Likes is highly overall correlated with Views | High correlation |
Artist is highly overall correlated with Unnamed: 0 and 1 other fields | High correlation |
Track is highly overall correlated with Title and 1 other fields | High correlation |
Title is highly overall correlated with Track and 1 other fields | High correlation |
Channel is highly overall correlated with Speechiness and 5 other fields | High correlation |
Licensed is highly overall correlated with Channel | High correlation |
Licensed is highly imbalanced (59.8%) | Imbalance |
Artist is uniformly distributed | Uniform |
Track is uniformly distributed | Uniform |
Title is uniformly distributed | Uniform |
Channel is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Key has 3 (6.0%) zeros | Zeros |
Instrumentalness has 23 (46.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-16 20:09:48.094629 |
|---|---|
| Analysis finished | 2023-05-16 20:10:07.468469 |
| Duration | 19.37 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 50 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11596.38 |
| Minimum | 126 |
|---|---|
| Maximum | 20308 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 126 |
|---|---|
| 5-th percentile | 199.75 |
| Q1 | 10777 |
| median | 13036 |
| Q3 | 15392 |
| 95-th percentile | 19244.6 |
| Maximum | 20308 |
| Range | 20182 |
| Interquartile range (IQR) | 4615 |
Descriptive statistics
| Standard deviation | 6037.5739 |
|---|---|
| Coefficient of variation (CV) | 0.52064298 |
| Kurtosis | -0.19016506 |
| Mean | 11596.38 |
| Median Absolute Deviation (MAD) | 2355 |
| Skewness | -0.95970362 |
| Sum | 579819 |
| Variance | 36452299 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1147 | 1 | 2.0% |
| 12480 | 1 | 2.0% |
| 14076 | 1 | 2.0% |
| 17951 | 1 | 2.0% |
| 157 | 1 | 2.0% |
| 15529 | 1 | 2.0% |
| 17195 | 1 | 2.0% |
| 13329 | 1 | 2.0% |
| 404 | 1 | 2.0% |
| 20308 | 1 | 2.0% |
| Other values (40) | 40 |
| Value | Count | Frequency (%) |
| 126 | 1 | |
| 154 | 1 | |
| 157 | 1 | |
| 252 | 1 | |
| 365 | 1 | |
| 366 | 1 | |
| 404 | 1 | |
| 744 | 1 | |
| 1147 | 1 | |
| 2466 | 1 |
| Value | Count | Frequency (%) |
| 20308 | 1 | |
| 20304 | 1 | |
| 20303 | 1 | |
| 17951 | 1 | |
| 17286 | 1 | |
| 17195 | 1 | |
| 16668 | 1 | |
| 16637 | 1 | |
| 16488 | 1 | |
| 15559 | 1 |
Artist
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 39 |
|---|---|
| Distinct (%) | 78.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| Ed Sheeran | 3 |
|---|---|
| CoComelon | 3 |
| Shakira | 2 |
| Charlie Puth | 2 |
| Daddy Yankee | 2 |
| Other values (34) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 10.06 |
| Min length | 2 |
Characters and Unicode
| Total characters | 503 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | 60.0% |
Sample
| 1st row | Luis Fonsi |
|---|---|
| 2nd row | Daddy Yankee |
| 3rd row | Ed Sheeran |
| 4th row | Charlie Puth |
| 5th row | Wiz Khalifa |
Common Values
| Value | Count | Frequency (%) |
| Ed Sheeran | 3 | 6.0% |
| CoComelon | 3 | 6.0% |
| Shakira | 2 | 4.0% |
| Charlie Puth | 2 | 4.0% |
| Daddy Yankee | 2 | 4.0% |
| Katy Perry | 2 | 4.0% |
| Justin Bieber | 2 | 4.0% |
| DJ Snake | 2 | 4.0% |
| Passenger | 2 | 4.0% |
| Eminem | 1 | 2.0% |
| Other values (29) | 29 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ed | 3 | 3.6% |
| cocomelon | 3 | 3.6% |
| sheeran | 3 | 3.6% |
| perry | 2 | 2.4% |
| passenger | 2 | 2.4% |
| dj | 2 | 2.4% |
| bieber | 2 | 2.4% |
| justin | 2 | 2.4% |
| snake | 2 | 2.4% |
| katy | 2 | 2.4% |
| Other values (56) | 61 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 55 | 10.9% |
| e | 46 | 9.1% |
| n | 40 | 8.0% |
| i | 34 | 6.8% |
| 34 | 6.8% | |
| r | 32 | 6.4% |
| l | 24 | 4.8% |
| o | 23 | 4.6% |
| h | 16 | 3.2% |
| s | 16 | 3.2% |
| Other values (39) | 183 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 376 | |
| Uppercase Letter | 92 | 18.3% |
| Space Separator | 34 | 6.8% |
| Decimal Number | 1 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 55 | |
| e | 46 | |
| n | 40 | |
| i | 34 | |
| r | 32 | |
| l | 24 | 6.4% |
| o | 23 | 6.1% |
| h | 16 | 4.3% |
| s | 16 | 4.3% |
| t | 14 | 3.7% |
| Other values (15) | 76 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 12 | |
| C | 11 | 12.0% |
| P | 9 | 9.8% |
| D | 7 | 7.6% |
| E | 6 | 6.5% |
| M | 5 | 5.4% |
| J | 4 | 4.3% |
| W | 4 | 4.3% |
| F | 3 | 3.3% |
| O | 3 | 3.3% |
| Other values (12) | 28 |
Space Separator
| Value | Count | Frequency (%) |
| 34 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 468 | |
| Common | 35 | 7.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 55 | 11.8% |
| e | 46 | 9.8% |
| n | 40 | 8.5% |
| i | 34 | 7.3% |
| r | 32 | 6.8% |
| l | 24 | 5.1% |
| o | 23 | 4.9% |
| h | 16 | 3.4% |
| s | 16 | 3.4% |
| t | 14 | 3.0% |
| Other values (37) | 168 |
Common
| Value | Count | Frequency (%) |
| 34 | ||
| 5 | 1 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 501 | |
| None | 2 | 0.4% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 55 | 11.0% |
| e | 46 | 9.2% |
| n | 40 | 8.0% |
| i | 34 | 6.8% |
| 34 | 6.8% | |
| r | 32 | 6.4% |
| l | 24 | 4.8% |
| o | 23 | 4.6% |
| h | 16 | 3.2% |
| s | 16 | 3.2% |
| Other values (37) | 181 |
None
| Value | Count | Frequency (%) |
| ó | 1 | |
| Ø | 1 |
Track
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 44 |
|---|---|
| Distinct (%) | 88.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| Despacito | 2 |
|---|---|
| This Is What You Came For | 2 |
| See You Again (feat. Charlie Puth) | 2 |
| Lean On | 2 |
| Taki Taki (with Selena Gomez, Ozuna & Cardi B) | 2 |
| Other values (39) |
Length
| Max length | 99 |
|---|---|
| Median length | 30 |
| Mean length | 19.36 |
| Min length | 4 |
Characters and Unicode
| Total characters | 968 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 10 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | 76.0% |
Sample
| 1st row | Despacito |
|---|---|
| 2nd row | Despacito |
| 3rd row | Shape of You |
| 4th row | See You Again (feat. Charlie Puth) |
| 5th row | See You Again (feat. Charlie Puth) |
Common Values
| Value | Count | Frequency (%) |
| Despacito | 2 | 4.0% |
| This Is What You Came For | 2 | 4.0% |
| See You Again (feat. Charlie Puth) | 2 | 4.0% |
| Lean On | 2 | 4.0% |
| Taki Taki (with Selena Gomez, Ozuna & Cardi B) | 2 | 4.0% |
| Calma - Remix | 2 | 4.0% |
| New Rules | 1 | 2.0% |
| Chantaje (feat. Maluma) | 1 | 2.0% |
| Rockabye (feat. Sean Paul & Anne-Marie) | 1 | 2.0% |
| Work from Home (feat. Ty Dolla $ign) | 1 | 2.0% |
| Other values (34) | 34 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| feat | 9 | 4.9% |
| you | 8 | 4.4% |
| 8 | 4.4% | |
| taki | 6 | 3.3% |
| gomez | 4 | 2.2% |
| selena | 4 | 2.2% |
| calma | 3 | 1.6% |
| this | 3 | 1.6% |
| b | 3 | 1.6% |
| the | 3 | 1.6% |
| Other values (105) | 132 |
Most occurring characters
| Value | Count | Frequency (%) |
| 133 | 13.7% | |
| a | 91 | 9.4% |
| e | 86 | 8.9% |
| o | 48 | 5.0% |
| i | 43 | 4.4% |
| n | 42 | 4.3% |
| t | 38 | 3.9% |
| r | 37 | 3.8% |
| l | 29 | 3.0% |
| u | 29 | 3.0% |
| Other values (55) | 392 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 613 | |
| Uppercase Letter | 160 | 16.5% |
| Space Separator | 133 | 13.7% |
| Other Punctuation | 17 | 1.8% |
| Open Punctuation | 15 | 1.5% |
| Close Punctuation | 15 | 1.5% |
| Dash Punctuation | 5 | 0.5% |
| Other Letter | 5 | 0.5% |
| Decimal Number | 4 | 0.4% |
| Currency Symbol | 1 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 91 | |
| e | 86 | |
| o | 48 | 7.8% |
| i | 43 | 7.0% |
| n | 42 | 6.9% |
| t | 38 | 6.2% |
| r | 37 | 6.0% |
| l | 29 | 4.7% |
| u | 29 | 4.7% |
| h | 26 | 4.2% |
| Other values (16) | 144 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 19 | |
| S | 19 | |
| C | 17 | |
| B | 16 | |
| W | 9 | 5.6% |
| A | 9 | 5.6% |
| L | 9 | 5.6% |
| Y | 8 | 5.0% |
| G | 8 | 5.0% |
| F | 7 | 4.4% |
| Other values (10) | 39 |
Other Letter
| Value | Count | Frequency (%) |
| 타 | 1 | |
| 일 | 1 | |
| 스 | 1 | |
| 남 | 1 | |
| 강 | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 9 | |
| & | 4 | |
| , | 3 | 17.6% |
| ' | 1 | 5.9% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 1 | 1 | |
| 2 | 1 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 14 | |
| [ | 1 | 6.7% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 14 | |
| ] | 1 | 6.7% |
Space Separator
| Value | Count | Frequency (%) |
| 133 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 773 | |
| Common | 190 | 19.6% |
| Hangul | 5 | 0.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 91 | 11.8% |
| e | 86 | 11.1% |
| o | 48 | 6.2% |
| i | 43 | 5.6% |
| n | 42 | 5.4% |
| t | 38 | 4.9% |
| r | 37 | 4.8% |
| l | 29 | 3.8% |
| u | 29 | 3.8% |
| h | 26 | 3.4% |
| Other values (36) | 304 |
Common
| Value | Count | Frequency (%) |
| 133 | ||
| ( | 14 | 7.4% |
| ) | 14 | 7.4% |
| . | 9 | 4.7% |
| - | 5 | 2.6% |
| & | 4 | 2.1% |
| , | 3 | 1.6% |
| 0 | 2 | 1.1% |
| ] | 1 | 0.5% |
| 1 | 1 | 0.5% |
| Other values (4) | 4 | 2.1% |
Hangul
| Value | Count | Frequency (%) |
| 타 | 1 | |
| 일 | 1 | |
| 스 | 1 | |
| 남 | 1 | |
| 강 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 962 | |
| Hangul | 5 | 0.5% |
| None | 1 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 133 | 13.8% | |
| a | 91 | 9.5% |
| e | 86 | 8.9% |
| o | 48 | 5.0% |
| i | 43 | 4.5% |
| n | 42 | 4.4% |
| t | 38 | 4.0% |
| r | 37 | 3.8% |
| l | 29 | 3.0% |
| u | 29 | 3.0% |
| Other values (49) | 386 |
Hangul
| Value | Count | Frequency (%) |
| 타 | 1 | |
| 일 | 1 | |
| 스 | 1 | |
| 남 | 1 | |
| 강 | 1 |
None
| Value | Count | Frequency (%) |
| é | 1 |
Danceability
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 82.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.70998 |
| Minimum | 0.399 |
|---|---|
| Maximum | 0.941 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.399 |
|---|---|
| 5-th percentile | 0.47295 |
| Q1 | 0.65425 |
| median | 0.7275 |
| Q3 | 0.7975 |
| 95-th percentile | 0.8542 |
| Maximum | 0.941 |
| Range | 0.542 |
| Interquartile range (IQR) | 0.14325 |
Descriptive statistics
| Standard deviation | 0.12158318 |
|---|---|
| Coefficient of variation (CV) | 0.17124874 |
| Kurtosis | 0.21751576 |
| Mean | 0.70998 |
| Median Absolute Deviation (MAD) | 0.0745 |
| Skewness | -0.66982951 |
| Sum | 35.499 |
| Variance | 0.014782469 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=41)
| Value | Count | Frequency (%) |
| 0.723 | 3 | 6.0% |
| 0.842 | 3 | 6.0% |
| 0.655 | 2 | 4.0% |
| 0.631 | 2 | 4.0% |
| 0.689 | 2 | 4.0% |
| 0.826 | 2 | 4.0% |
| 0.728 | 2 | 4.0% |
| 0.852 | 1 | 2.0% |
| 0.717 | 1 | 2.0% |
| 0.803 | 1 | 2.0% |
| Other values (31) | 31 |
| Value | Count | Frequency (%) |
| 0.399 | 1 | |
| 0.444 | 1 | |
| 0.468 | 1 | |
| 0.479 | 1 | |
| 0.489 | 1 | |
| 0.547 | 1 | |
| 0.548 | 1 | |
| 0.589 | 1 | |
| 0.599 | 1 | |
| 0.631 | 2 |
| Value | Count | Frequency (%) |
| 0.941 | 1 | 2.0% |
| 0.918 | 1 | 2.0% |
| 0.856 | 1 | 2.0% |
| 0.852 | 1 | 2.0% |
| 0.842 | 3 | |
| 0.826 | 2 | |
| 0.825 | 1 | 2.0% |
| 0.814 | 1 | 2.0% |
| 0.807 | 1 | 2.0% |
| 0.803 | 1 | 2.0% |
Energy
Real number (ℝ)
| Distinct | 42 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.702138 |
| Minimum | 0.0739 |
|---|---|
| Maximum | 0.937 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.0739 |
|---|---|
| 5-th percentile | 0.41805 |
| Q1 | 0.59825 |
| median | 0.764 |
| Q3 | 0.807 |
| 95-th percentile | 0.9261 |
| Maximum | 0.937 |
| Range | 0.8631 |
| Interquartile range (IQR) | 0.20875 |
Descriptive statistics
| Standard deviation | 0.17138259 |
|---|---|
| Coefficient of variation (CV) | 0.24408676 |
| Kurtosis | 2.3125648 |
| Mean | 0.702138 |
| Median Absolute Deviation (MAD) | 0.1015 |
| Skewness | -1.2365294 |
| Sum | 35.1069 |
| Variance | 0.029371993 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=42)
| Value | Count | Frequency (%) |
| 0.801 | 3 | 6.0% |
| 0.797 | 2 | 4.0% |
| 0.927 | 2 | 4.0% |
| 0.481 | 2 | 4.0% |
| 0.809 | 2 | 4.0% |
| 0.764 | 2 | 4.0% |
| 0.585 | 2 | 4.0% |
| 0.7 | 1 | 2.0% |
| 0.773 | 1 | 2.0% |
| 0.73 | 1 | 2.0% |
| Other values (32) | 32 |
| Value | Count | Frequency (%) |
| 0.0739 | 1 | |
| 0.387 | 1 | |
| 0.396 | 1 | |
| 0.445 | 1 | |
| 0.448 | 1 | |
| 0.481 | 2 | |
| 0.545 | 1 | |
| 0.563 | 1 | |
| 0.585 | 2 | |
| 0.587 | 1 |
| Value | Count | Frequency (%) |
| 0.937 | 1 | |
| 0.927 | 2 | |
| 0.925 | 1 | |
| 0.887 | 1 | |
| 0.885 | 1 | |
| 0.871 | 1 | |
| 0.86 | 1 | |
| 0.859 | 1 | |
| 0.819 | 1 | |
| 0.813 | 1 |
Key
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 22.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.08 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 3 |
| Zeros (%) | 6.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.45 |
| Q1 | 2.5 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 6.5 |
Descriptive statistics
| Standard deviation | 3.4983378 |
|---|---|
| Coefficient of variation (CV) | 0.57538451 |
| Kurtosis | -1.197745 |
| Mean | 6.08 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.36145005 |
| Sum | 304 |
| Variance | 12.238367 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 8 | 7 | |
| 9 | 6 | |
| 7 | 6 | |
| 2 | 5 | |
| 1 | 5 | |
| 10 | 5 | |
| 11 | 4 | |
| 4 | 4 | |
| 0 | 3 | |
| 5 | 3 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 1 | 5 | |
| 2 | 5 | |
| 4 | 4 | |
| 5 | 3 | |
| 6 | 2 | 4.0% |
| 7 | 6 | |
| 8 | 7 | |
| 9 | 6 | |
| 10 | 5 |
| Value | Count | Frequency (%) |
| 11 | 4 | |
| 10 | 5 | |
| 9 | 6 | |
| 8 | 7 | |
| 7 | 6 | |
| 6 | 2 | 4.0% |
| 5 | 3 | |
| 4 | 4 | |
| 2 | 5 | |
| 1 | 5 |
Loudness
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5.31906 |
| Minimum | -13.961 |
|---|---|
| Maximum | -2.652 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 50 |
| Negative (%) | 100.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | -13.961 |
|---|---|
| 5-th percentile | -9.85525 |
| Q1 | -6.26475 |
| median | -4.804 |
| Q3 | -3.68325 |
| 95-th percentile | -2.8248 |
| Maximum | -2.652 |
| Range | 11.309 |
| Interquartile range (IQR) | 2.5815 |
Descriptive statistics
| Standard deviation | 2.3767322 |
|---|---|
| Coefficient of variation (CV) | -0.44683313 |
| Kurtosis | 3.5479009 |
| Mean | -5.31906 |
| Median Absolute Deviation (MAD) | 1.31 |
| Skewness | -1.6794373 |
| Sum | -265.953 |
| Variance | 5.648856 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| -4.167 | 3 | 6.0% |
| -4.787 | 2 | 4.0% |
| -2.787 | 2 | 4.0% |
| -7.503 | 2 | 4.0% |
| -3.081 | 2 | 4.0% |
| -4.341 | 2 | 4.0% |
| -6.021 | 1 | 2.0% |
| -2.921 | 1 | 2.0% |
| -4.729 | 1 | 2.0% |
| -5.861 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| -13.961 | 1 | |
| -11.92 | 1 | |
| -11.266 | 1 | |
| -8.131 | 1 | |
| -8.053 | 1 | |
| -7.503 | 2 | |
| -7.346 | 1 | |
| -7.223 | 1 | |
| -7.055 | 1 | |
| -6.633 | 1 |
| Value | Count | Frequency (%) |
| -2.652 | 1 | |
| -2.787 | 2 | |
| -2.871 | 1 | |
| -2.88 | 1 | |
| -2.921 | 1 | |
| -3.023 | 1 | |
| -3.081 | 2 | |
| -3.183 | 1 | |
| -3.4 | 1 | |
| -3.503 | 1 |
Speechiness
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.092564 |
| Minimum | 0.0232 |
|---|---|
| Maximum | 0.341 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.0232 |
|---|---|
| 5-th percentile | 0.030445 |
| Q1 | 0.04785 |
| median | 0.06345 |
| Q3 | 0.12475 |
| 95-th percentile | 0.228 |
| Maximum | 0.341 |
| Range | 0.3178 |
| Interquartile range (IQR) | 0.0769 |
Descriptive statistics
| Standard deviation | 0.072001147 |
|---|---|
| Coefficient of variation (CV) | 0.77785259 |
| Kurtosis | 2.6190593 |
| Mean | 0.092564 |
| Median Absolute Deviation (MAD) | 0.0205 |
| Skewness | 1.7166665 |
| Sum | 4.6282 |
| Variance | 0.0051841652 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 0.228 | 3 | 6.0% |
| 0.153 | 2 | 4.0% |
| 0.0332 | 2 | 4.0% |
| 0.0815 | 2 | 4.0% |
| 0.0625 | 2 | 4.0% |
| 0.0522 | 2 | 4.0% |
| 0.0694 | 1 | 2.0% |
| 0.0776 | 1 | 2.0% |
| 0.0568 | 1 | 2.0% |
| 0.0432 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 0.0232 | 1 | |
| 0.0292 | 1 | |
| 0.0295 | 1 | |
| 0.0316 | 1 | |
| 0.0332 | 2 | |
| 0.0334 | 1 | |
| 0.035 | 1 | |
| 0.0382 | 1 | |
| 0.0427 | 1 | |
| 0.0432 | 1 |
| Value | Count | Frequency (%) |
| 0.341 | 1 | 2.0% |
| 0.286 | 1 | 2.0% |
| 0.228 | 3 | |
| 0.227 | 1 | 2.0% |
| 0.153 | 2 | |
| 0.147 | 1 | 2.0% |
| 0.141 | 1 | 2.0% |
| 0.137 | 1 | 2.0% |
| 0.134 | 1 | 2.0% |
| 0.128 | 1 | 2.0% |
Acousticness
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2037234 |
| Minimum | 0.00261 |
|---|---|
| Maximum | 0.948 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.00261 |
|---|---|
| 5-th percentile | 0.00346 |
| Q1 | 0.040725 |
| median | 0.157 |
| Q3 | 0.33525 |
| 95-th percentile | 0.603 |
| Maximum | 0.948 |
| Range | 0.94539 |
| Interquartile range (IQR) | 0.294525 |
Descriptive statistics
| Standard deviation | 0.21821352 |
|---|---|
| Coefficient of variation (CV) | 1.0711265 |
| Kurtosis | 2.4642749 |
| Mean | 0.2037234 |
| Median Absolute Deviation (MAD) | 0.12795 |
| Skewness | 1.5524364 |
| Sum | 10.18617 |
| Variance | 0.047617142 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 0.157 | 3 | 6.0% |
| 0.198 | 2 | 4.0% |
| 0.199 | 2 | 4.0% |
| 0.369 | 2 | 4.0% |
| 0.00346 | 2 | 4.0% |
| 0.337 | 2 | 4.0% |
| 0.00261 | 1 | 2.0% |
| 0.187 | 1 | 2.0% |
| 0.383 | 1 | 2.0% |
| 0.103 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 0.00261 | 1 | |
| 0.00314 | 1 | |
| 0.00346 | 2 | |
| 0.00417 | 1 | |
| 0.00492 | 1 | |
| 0.0062 | 1 | |
| 0.00801 | 1 | |
| 0.0168 | 1 | |
| 0.0197 | 1 | |
| 0.0281 | 1 |
| Value | Count | Frequency (%) |
| 0.948 | 1 | |
| 0.829 | 1 | |
| 0.621 | 1 | |
| 0.581 | 1 | |
| 0.545 | 1 | |
| 0.474 | 1 | |
| 0.401 | 1 | |
| 0.383 | 1 | |
| 0.369 | 2 | |
| 0.365 | 1 |
Instrumentalness
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 22 |
|---|---|
| Distinct (%) | 44.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0048180554 |
| Minimum | 0 |
|---|---|
| Maximum | 0.119 |
| Zeros | 23 |
| Zeros (%) | 46.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1.335 × 10-6 |
| Q3 | 1.36925 × 10-5 |
| 95-th percentile | 0.00123 |
| Maximum | 0.119 |
| Range | 0.119 |
| Interquartile range (IQR) | 1.36925 × 10-5 |
Descriptive statistics
| Standard deviation | 0.023545166 |
|---|---|
| Coefficient of variation (CV) | 4.8868607 |
| Kurtosis | 22.325355 |
| Mean | 0.0048180554 |
| Median Absolute Deviation (MAD) | 1.335 × 10-6 |
| Skewness | 4.8404928 |
| Sum | 0.24090277 |
| Variance | 0.00055437482 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 0 | 23 | |
| 4.82 × 10-6 | 3 | 6.0% |
| 7.28 × 10-6 | 2 | 4.0% |
| 0.00123 | 2 | 4.0% |
| 0.119 | 2 | 4.0% |
| 1.03 × 10-6 | 2 | 4.0% |
| 2.88 × 10-5 | 1 | 2.0% |
| 3.85 × 10-6 | 1 | 2.0% |
| 9.33 × 10-5 | 1 | 2.0% |
| 2.87 × 10-6 | 1 | 2.0% |
| Other values (12) | 12 |
| Value | Count | Frequency (%) |
| 0 | 23 | |
| 1.03 × 10-6 | 2 | 4.0% |
| 1.64 × 10-6 | 1 | 2.0% |
| 1.94 × 10-6 | 1 | 2.0% |
| 2.87 × 10-6 | 1 | 2.0% |
| 3.68 × 10-6 | 1 | 2.0% |
| 3.85 × 10-6 | 1 | 2.0% |
| 3.94 × 10-6 | 1 | 2.0% |
| 4.82 × 10-6 | 3 | 6.0% |
| 7.28 × 10-6 | 2 | 4.0% |
| Value | Count | Frequency (%) |
| 0.119 | 2 | |
| 0.00123 | 2 | |
| 9.33 × 10-5 | 1 | |
| 8.15 × 10-5 | 1 | |
| 6.07 × 10-5 | 1 | |
| 3.05 × 10-5 | 1 | |
| 3 × 10-5 | 1 | |
| 2.88 × 10-5 | 1 | |
| 2.29 × 10-5 | 1 | |
| 2.25 × 10-5 | 1 |
Liveness
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.148822 |
| Minimum | 0.0344 |
|---|---|
| Maximum | 0.565 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.0344 |
|---|---|
| 5-th percentile | 0.05866 |
| Q1 | 0.067375 |
| median | 0.109 |
| Q3 | 0.1585 |
| 95-th percentile | 0.4651 |
| Maximum | 0.565 |
| Range | 0.5306 |
| Interquartile range (IQR) | 0.091125 |
Descriptive statistics
| Standard deviation | 0.12577595 |
|---|---|
| Coefficient of variation (CV) | 0.84514354 |
| Kurtosis | 4.7597515 |
| Mean | 0.148822 |
| Median Absolute Deviation (MAD) | 0.04335 |
| Skewness | 2.2649892 |
| Sum | 7.4411 |
| Variance | 0.01581959 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 0.0642 | 3 | 6.0% |
| 0.067 | 2 | 4.0% |
| 0.148 | 2 | 4.0% |
| 0.0649 | 2 | 4.0% |
| 0.565 | 2 | 4.0% |
| 0.161 | 2 | 4.0% |
| 0.153 | 1 | 2.0% |
| 0.159 | 1 | 2.0% |
| 0.398 | 1 | 2.0% |
| 0.0644 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 0.0344 | 1 | 2.0% |
| 0.0451 | 1 | 2.0% |
| 0.0574 | 1 | 2.0% |
| 0.0602 | 1 | 2.0% |
| 0.0642 | 3 | |
| 0.0644 | 1 | 2.0% |
| 0.0649 | 2 | |
| 0.0663 | 1 | 2.0% |
| 0.067 | 2 | |
| 0.0685 | 1 | 2.0% |
| Value | Count | Frequency (%) |
| 0.565 | 2 | |
| 0.52 | 1 | |
| 0.398 | 1 | |
| 0.354 | 1 | |
| 0.299 | 1 | |
| 0.255 | 1 | |
| 0.184 | 1 | |
| 0.179 | 1 | |
| 0.165 | 1 | |
| 0.161 | 2 |
Valence
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 82.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.59862 |
| Minimum | 0.158 |
|---|---|
| Maximum | 0.969 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.158 |
|---|---|
| 5-th percentile | 0.20175 |
| Q1 | 0.36725 |
| median | 0.617 |
| Q3 | 0.82125 |
| 95-th percentile | 0.961 |
| Maximum | 0.969 |
| Range | 0.811 |
| Interquartile range (IQR) | 0.454 |
Descriptive statistics
| Standard deviation | 0.25013824 |
|---|---|
| Coefficient of variation (CV) | 0.41785814 |
| Kurtosis | -1.1606165 |
| Mean | 0.59862 |
| Median Absolute Deviation (MAD) | 0.218 |
| Skewness | -0.18539332 |
| Sum | 29.931 |
| Variance | 0.062569138 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=41)
| Value | Count | Frequency (%) |
| 0.839 | 3 | 6.0% |
| 0.617 | 3 | 6.0% |
| 0.761 | 2 | 4.0% |
| 0.283 | 2 | 4.0% |
| 0.274 | 2 | 4.0% |
| 0.961 | 2 | 4.0% |
| 0.465 | 2 | 4.0% |
| 0.535 | 1 | 2.0% |
| 0.608 | 1 | 2.0% |
| 0.907 | 1 | 2.0% |
| Other values (31) | 31 |
| Value | Count | Frequency (%) |
| 0.158 | 1 | |
| 0.159 | 1 | |
| 0.168 | 1 | |
| 0.243 | 1 | |
| 0.25 | 1 | |
| 0.274 | 2 | |
| 0.283 | 2 | |
| 0.288 | 1 | |
| 0.324 | 1 | |
| 0.352 | 1 |
| Value | Count | Frequency (%) |
| 0.969 | 1 | 2.0% |
| 0.965 | 1 | 2.0% |
| 0.961 | 2 | |
| 0.931 | 1 | 2.0% |
| 0.928 | 1 | 2.0% |
| 0.908 | 1 | 2.0% |
| 0.907 | 1 | 2.0% |
| 0.884 | 1 | 2.0% |
| 0.839 | 3 | |
| 0.831 | 1 | 2.0% |
Tempo
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.7097 |
| Minimum | 65.043 |
|---|---|
| Maximum | 199.956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 65.043 |
|---|---|
| 5-th percentile | 79.44755 |
| Q1 | 95.0215 |
| median | 102.018 |
| Q3 | 126.43025 |
| 95-th percentile | 178.8707 |
| Maximum | 199.956 |
| Range | 134.913 |
| Interquartile range (IQR) | 31.40875 |
Descriptive statistics
| Standard deviation | 31.843524 |
|---|---|
| Coefficient of variation (CV) | 0.28004228 |
| Kurtosis | 1.1041879 |
| Mean | 113.7097 |
| Median Absolute Deviation (MAD) | 18.6905 |
| Skewness | 1.2163691 |
| Sum | 5685.485 |
| Variance | 1014.01 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 95.881 | 3 | 6.0% |
| 177.928 | 2 | 4.0% |
| 123.962 | 2 | 4.0% |
| 80.025 | 2 | 4.0% |
| 98.007 | 2 | 4.0% |
| 126.9 | 2 | 4.0% |
| 116.073 | 1 | 2.0% |
| 102.034 | 1 | 2.0% |
| 102.002 | 1 | 2.0% |
| 105.017 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 65.043 | 1 | |
| 74.897 | 1 | |
| 78.998 | 1 | |
| 79.997 | 1 | |
| 80.025 | 2 | |
| 82.695 | 1 | |
| 86.989 | 1 | |
| 90.003 | 1 | |
| 91.01 | 1 | |
| 91.017 | 1 |
| Value | Count | Frequency (%) |
| 199.956 | 1 | |
| 199.955 | 1 | |
| 179.642 | 1 | |
| 177.928 | 2 | |
| 169.977 | 1 | |
| 142.526 | 1 | |
| 134.052 | 1 | |
| 132.067 | 1 | |
| 131.934 | 1 | |
| 126.994 | 1 |
Duration_ms
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 228234.58 |
| Minimum | 127203 |
|---|---|
| Maximum | 586076 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 127203 |
|---|---|
| 5-th percentile | 176561 |
| Q1 | 205095.25 |
| median | 220826.5 |
| Q3 | 237627 |
| 95-th percentile | 272981.3 |
| Maximum | 586076 |
| Range | 458873 |
| Interquartile range (IQR) | 32531.75 |
Descriptive statistics
| Standard deviation | 60068.891 |
|---|---|
| Coefficient of variation (CV) | 0.26318926 |
| Kurtosis | 26.208465 |
| Mean | 228234.58 |
| Median Absolute Deviation (MAD) | 16800.5 |
| Skewness | 4.3294428 |
| Sum | 11411729 |
| Variance | 3.6082716 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 212500 | 3 | 6.0% |
| 229360 | 2 | 4.0% |
| 222160 | 2 | 4.0% |
| 229526 | 2 | 4.0% |
| 176561 | 2 | 4.0% |
| 237627 | 2 | 4.0% |
| 209320 | 1 | 2.0% |
| 195840 | 1 | 2.0% |
| 251173 | 1 | 2.0% |
| 214480 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 127203 | 1 | |
| 147781 | 1 | |
| 176561 | 2 | |
| 185040 | 1 | |
| 187920 | 1 | |
| 187973 | 1 | |
| 193227 | 1 | |
| 195840 | 1 | |
| 200787 | 1 | |
| 202333 | 1 |
| Value | Count | Frequency (%) |
| 586076 | 1 | |
| 281560 | 1 | |
| 275693 | 1 | |
| 269667 | 1 | |
| 266627 | 1 | |
| 263400 | 1 | |
| 263373 | 1 | |
| 257840 | 1 | |
| 253520 | 1 | |
| 252733 | 1 |
Title
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 42 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| DJ Snake - Taki Taki ft. Selena Gomez, Ozuna, Cardi B (Official Music Video) | 3 |
|---|---|
| Luis Fonsi - Despacito ft. Daddy Yankee | 2 |
| Calvin Harris, Rihanna - This Is What You Came For (Official Video) ft. Rihanna | 2 |
| Wiz Khalifa - See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack | 2 |
| Major Lazer & DJ Snake - Lean On (feat. MØ) (Official Music Video) | 2 |
| Other values (37) |
Length
| Max length | 100 |
|---|---|
| Median length | 65 |
| Mean length | 54.44 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2722 |
|---|---|
| Distinct characters | 92 |
| Distinct categories | 14 ? |
| Distinct scripts | 4 ? |
| Distinct blocks | 6 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 35 ? |
|---|---|
| Unique (%) | 70.0% |
Sample
| 1st row | Luis Fonsi - Despacito ft. Daddy Yankee |
|---|---|
| 2nd row | Luis Fonsi - Despacito ft. Daddy Yankee |
| 3rd row | Ed Sheeran - Shape of You (Official Music Video) |
| 4th row | Wiz Khalifa - See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack |
| 5th row | Wiz Khalifa - See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack |
Common Values
| Value | Count | Frequency (%) |
| DJ Snake - Taki Taki ft. Selena Gomez, Ozuna, Cardi B (Official Music Video) | 3 | 6.0% |
| Luis Fonsi - Despacito ft. Daddy Yankee | 2 | 4.0% |
| Calvin Harris, Rihanna - This Is What You Came For (Official Video) ft. Rihanna | 2 | 4.0% |
| Wiz Khalifa - See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack | 2 | 4.0% |
| Major Lazer & DJ Snake - Lean On (feat. MØ) (Official Music Video) | 2 | 4.0% |
| Pedro Capó, Farruko - Calma (Remix - Official Video) | 2 | 4.0% |
| Passenger | Let Her Go (Official Video) | 2 | 4.0% |
| Shakira - Chantaje (Official Video) ft. Maluma | 1 | 2.0% |
| Clean Bandit - Rockabye (feat. Sean Paul & Anne-Marie) [Official Video] | 1 | 2.0% |
| Fifth Harmony - Work from Home (Official Video) ft. Ty Dolla $ign | 1 | 2.0% |
| Other values (32) | 32 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 58 | 12.1% | |
| video | 34 | 7.1% |
| official | 34 | 7.1% |
| ft | 16 | 3.3% |
| music | 12 | 2.5% |
| you | 8 | 1.7% |
| taki | 6 | 1.3% |
| dj | 5 | 1.0% |
| ozuna | 5 | 1.0% |
| rihanna | 5 | 1.0% |
| Other values (201) | 295 |
Most occurring characters
| Value | Count | Frequency (%) |
| 428 | 15.7% | |
| a | 206 | 7.6% |
| i | 205 | 7.5% |
| e | 180 | 6.6% |
| o | 118 | 4.3% |
| n | 105 | 3.9% |
| f | 97 | 3.6% |
| l | 90 | 3.3% |
| r | 86 | 3.2% |
| s | 68 | 2.5% |
| Other values (82) | 1139 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1627 | |
| Uppercase Letter | 447 | 16.4% |
| Space Separator | 428 | 15.7% |
| Other Punctuation | 50 | 1.8% |
| Dash Punctuation | 46 | 1.7% |
| Close Punctuation | 44 | 1.6% |
| Open Punctuation | 44 | 1.6% |
| Other Letter | 14 | 0.5% |
| Decimal Number | 7 | 0.3% |
| Math Symbol | 5 | 0.2% |
| Other values (4) | 10 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 206 | |
| i | 205 | |
| e | 180 | |
| o | 118 | 7.3% |
| n | 105 | 6.5% |
| f | 97 | 6.0% |
| l | 90 | 5.5% |
| r | 86 | 5.3% |
| s | 68 | 4.2% |
| u | 67 | 4.1% |
| Other values (19) | 405 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 48 | 10.7% |
| S | 40 | 8.9% |
| V | 35 | 7.8% |
| C | 32 | 7.2% |
| M | 29 | 6.5% |
| B | 23 | 5.1% |
| T | 22 | 4.9% |
| D | 21 | 4.7% |
| R | 20 | 4.5% |
| L | 18 | 4.0% |
| Other values (15) | 159 |
Other Letter
| Value | Count | Frequency (%) |
| न | 2 | |
| 스 | 1 | 7.1% |
| 타 | 1 | 7.1% |
| 일 | 1 | 7.1% |
| 강 | 1 | 7.1% |
| 남 | 1 | 7.1% |
| स | 1 | 7.1% |
| ल | 1 | 7.1% |
| च | 1 | 7.1% |
| म | 1 | 7.1% |
| Other values (3) | 3 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 20 | |
| , | 19 | |
| & | 7 | 14.0% |
| : | 2 | 4.0% |
| / | 1 | 2.0% |
| ' | 1 | 2.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 2 | |
| 0 | 2 | |
| 5 | 1 | |
| 2 | 1 | |
| 1 | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 38 | |
| ] | 6 | 13.6% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 38 | |
| [ | 6 | 13.6% |
Spacing Mark
| Value | Count | Frequency (%) |
| ा | 3 | |
| ी | 2 |
Other Symbol
| Value | Count | Frequency (%) |
| ™ | 1 | |
| ❌ | 1 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ् | 1 | |
| ु | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 428 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 46 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 5 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2074 | |
| Common | 627 | 23.0% |
| Devanagari | 16 | 0.6% |
| Hangul | 5 | 0.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 206 | 9.9% |
| i | 205 | 9.9% |
| e | 180 | 8.7% |
| o | 118 | 5.7% |
| n | 105 | 5.1% |
| f | 97 | 4.7% |
| l | 90 | 4.3% |
| r | 86 | 4.1% |
| s | 68 | 3.3% |
| u | 67 | 3.2% |
| Other values (44) | 852 |
Common
| Value | Count | Frequency (%) |
| 428 | ||
| - | 46 | 7.3% |
| ) | 38 | 6.1% |
| ( | 38 | 6.1% |
| . | 20 | 3.2% |
| , | 19 | 3.0% |
| & | 7 | 1.1% |
| ] | 6 | 1.0% |
| [ | 6 | 1.0% |
| | | 5 | 0.8% |
| Other values (11) | 14 | 2.2% |
Devanagari
| Value | Count | Frequency (%) |
| ा | 3 | |
| ी | 2 | |
| न | 2 | |
| ् | 1 | 6.2% |
| स | 1 | 6.2% |
| ल | 1 | 6.2% |
| च | 1 | 6.2% |
| म | 1 | 6.2% |
| ु | 1 | 6.2% |
| ह | 1 | 6.2% |
| Other values (2) | 2 |
Hangul
| Value | Count | Frequency (%) |
| 스 | 1 | |
| 타 | 1 | |
| 일 | 1 | |
| 강 | 1 | |
| 남 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2693 | |
| Devanagari | 16 | 0.6% |
| None | 6 | 0.2% |
| Hangul | 5 | 0.2% |
| Letterlike Symbols | 1 | < 0.1% |
| Dingbats | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 428 | 15.9% | |
| a | 206 | 7.6% |
| i | 205 | 7.6% |
| e | 180 | 6.7% |
| o | 118 | 4.4% |
| n | 105 | 3.9% |
| f | 97 | 3.6% |
| l | 90 | 3.3% |
| r | 86 | 3.2% |
| s | 68 | 2.5% |
| Other values (59) | 1110 |
Devanagari
| Value | Count | Frequency (%) |
| ा | 3 | |
| ी | 2 | |
| न | 2 | |
| ् | 1 | 6.2% |
| स | 1 | 6.2% |
| ल | 1 | 6.2% |
| च | 1 | 6.2% |
| म | 1 | 6.2% |
| ु | 1 | 6.2% |
| ह | 1 | 6.2% |
| Other values (2) | 2 |
None
| Value | Count | Frequency (%) |
| ó | 2 | |
| Ø | 2 | |
| í | 1 | |
| ñ | 1 |
Hangul
| Value | Count | Frequency (%) |
| 스 | 1 | |
| 타 | 1 | |
| 일 | 1 | |
| 강 | 1 | |
| 남 | 1 |
Letterlike Symbols
| Value | Count | Frequency (%) |
| ™ | 1 |
Dingbats
| Value | Count | Frequency (%) |
| ❌ | 1 |
Channel
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 35 |
|---|---|
| Distinct (%) | 70.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| Cocomelon - Nursery Rhymes | 3 |
|---|---|
| Ed Sheeran | 3 |
| DJSnakeVEVO | 3 |
| LuisFonsiVEVO | 2 |
| JustinBieberVEVO | 2 |
| Other values (30) |
Length
| Max length | 26 |
|---|---|
| Median length | 18 |
| Mean length | 14.02 |
| Min length | 7 |
Characters and Unicode
| Total characters | 701 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 46.0% |
Sample
| 1st row | LuisFonsiVEVO |
|---|---|
| 2nd row | LuisFonsiVEVO |
| 3rd row | Ed Sheeran |
| 4th row | Wiz Khalifa Music |
| 5th row | Wiz Khalifa Music |
Common Values
| Value | Count | Frequency (%) |
| Cocomelon - Nursery Rhymes | 3 | 6.0% |
| Ed Sheeran | 3 | 6.0% |
| DJSnakeVEVO | 3 | 6.0% |
| LuisFonsiVEVO | 2 | 4.0% |
| JustinBieberVEVO | 2 | 4.0% |
| CalvinHarrisVEVO | 2 | 4.0% |
| Major Lazer Official | 2 | 4.0% |
| Passenger | 2 | 4.0% |
| capoVEVO | 2 | 4.0% |
| shakiraVEVO | 2 | 4.0% |
| Other values (25) | 27 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| cocomelon | 3 | 3.7% |
| nursery | 3 | 3.7% |
| rhymes | 3 | 3.7% |
| ed | 3 | 3.7% |
| sheeran | 3 | 3.7% |
| djsnakevevo | 3 | 3.7% |
| 3 | 3.7% | |
| passenger | 2 | 2.4% |
| music | 2 | 2.4% |
| wiz | 2 | 2.4% |
| Other values (45) | 55 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 57 | 8.1% |
| V | 56 | 8.0% |
| e | 51 | 7.3% |
| i | 44 | 6.3% |
| r | 39 | 5.6% |
| n | 37 | 5.3% |
| E | 34 | 4.9% |
| 33 | 4.7% | |
| O | 31 | 4.4% |
| s | 29 | 4.1% |
| Other values (40) | 290 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 444 | |
| Uppercase Letter | 219 | |
| Space Separator | 33 | 4.7% |
| Dash Punctuation | 4 | 0.6% |
| Decimal Number | 1 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 57 | |
| e | 51 | |
| i | 44 | |
| r | 39 | 8.8% |
| n | 37 | 8.3% |
| s | 29 | 6.5% |
| o | 27 | 6.1% |
| l | 23 | 5.2% |
| h | 16 | 3.6% |
| y | 15 | 3.4% |
| Other values (15) | 106 |
Uppercase Letter
| Value | Count | Frequency (%) |
| V | 56 | |
| E | 34 | |
| O | 31 | |
| S | 12 | 5.5% |
| M | 9 | 4.1% |
| C | 7 | 3.2% |
| T | 6 | 2.7% |
| L | 6 | 2.7% |
| R | 6 | 2.7% |
| D | 6 | 2.7% |
| Other values (12) | 46 |
Space Separator
| Value | Count | Frequency (%) |
| 33 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 663 | |
| Common | 38 | 5.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 57 | 8.6% |
| V | 56 | 8.4% |
| e | 51 | 7.7% |
| i | 44 | 6.6% |
| r | 39 | 5.9% |
| n | 37 | 5.6% |
| E | 34 | 5.1% |
| O | 31 | 4.7% |
| s | 29 | 4.4% |
| o | 27 | 4.1% |
| Other values (37) | 258 |
Common
| Value | Count | Frequency (%) |
| 33 | ||
| - | 4 | 10.5% |
| 5 | 1 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 701 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 57 | 8.1% |
| V | 56 | 8.0% |
| e | 51 | 7.3% |
| i | 44 | 6.3% |
| r | 39 | 5.6% |
| n | 37 | 5.3% |
| E | 34 | 4.9% |
| 33 | 4.7% | |
| O | 31 | 4.4% |
| s | 29 | 4.1% |
| Other values (40) | 290 |
Views
Real number (ℝ)
| Distinct | 48 |
|---|---|
| Distinct (%) | 96.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4317244 × 109 |
| Minimum | 2.2837481 × 109 |
|---|---|
| Maximum | 8.0796494 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 2.2837481 × 109 |
|---|---|
| 5-th percentile | 2.3613016 × 109 |
| Q1 | 2.6260299 × 109 |
| median | 3.0124999 × 109 |
| Q3 | 3.531993 × 109 |
| 95-th percentile | 5.8478284 × 109 |
| Maximum | 8.0796494 × 109 |
| Range | 5.7959013 × 109 |
| Interquartile range (IQR) | 9.0596308 × 108 |
Descriptive statistics
| Standard deviation | 1.3151666 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.38323783 |
| Kurtosis | 4.9622199 |
| Mean | 3.4317244 × 109 |
| Median Absolute Deviation (MAD) | 4.3975906 × 108 |
| Skewness | 2.1771368 |
| Sum | 1.7158622 × 1011 |
| Variance | 1.7296633 × 1018 |
| Monotonicity | Decreasing |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 3376086171 | 2 | 4.0% |
| 2626029906 | 2 | 4.0% |
| 8079649362 | 1 | 2.0% |
| 2925709616 | 1 | 2.0% |
| 2809699009 | 1 | 2.0% |
| 2805793003 | 1 | 2.0% |
| 2761229559 | 1 | 2.0% |
| 2666673882 | 1 | 2.0% |
| 2661008889 | 1 | 2.0% |
| 2661002503 | 1 | 2.0% |
| Other values (38) | 38 |
| Value | Count | Frequency (%) |
| 2283748076 | 1 | |
| 2315953928 | 1 | |
| 2354418112 | 1 | |
| 2369714846 | 1 | |
| 2414201310 | 1 | |
| 2414201716 | 1 | |
| 2414202125 | 1 | |
| 2447960265 | 1 | |
| 2539156924 | 1 | |
| 2563945395 | 1 |
| Value | Count | Frequency (%) |
| 8079649362 | 1 | |
| 8079646911 | 1 | |
| 5908398479 | 1 | |
| 5773798407 | 1 | |
| 5773797147 | 1 | |
| 4898831101 | 1 | |
| 4821016218 | 1 | |
| 4679767471 | 1 | |
| 3817733132 | 1 | |
| 3725748519 | 1 |
Likes
Real number (ℝ)
| Distinct | 48 |
|---|---|
| Distinct (%) | 96.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17734660 |
| Minimum | 6604353 |
|---|---|
| Maximum | 50788652 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 6604353 |
|---|---|
| 5-th percentile | 9197448.2 |
| Q1 | 12432697 |
| median | 15361684 |
| Q3 | 18776038 |
| 95-th percentile | 40147649 |
| Maximum | 50788652 |
| Range | 44184299 |
| Interquartile range (IQR) | 6343341.8 |
Descriptive statistics
| Standard deviation | 9658910.6 |
|---|---|
| Coefficient of variation (CV) | 0.54463466 |
| Kurtosis | 4.7424395 |
| Mean | 17734660 |
| Median Absolute Deviation (MAD) | 3414333.5 |
| Skewness | 2.1554919 |
| Sum | 8.8673301 × 108 |
| Variance | 9.3294554 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 15361684 | 2 | 4.0% |
| 10603656 | 2 | 4.0% |
| 50788652 | 1 | 2.0% |
| 13643149 | 1 | 2.0% |
| 16730579 | 1 | 2.0% |
| 10370533 | 1 | 2.0% |
| 13333328 | 1 | 2.0% |
| 11869546 | 1 | 2.0% |
| 12824789 | 1 | 2.0% |
| 12824730 | 1 | 2.0% |
| Other values (38) | 38 |
| Value | Count | Frequency (%) |
| 6604353 | 1 | |
| 8195497 | 1 | |
| 8943443 | 1 | |
| 9507899 | 1 | |
| 10159799 | 1 | |
| 10169573 | 1 | |
| 10370533 | 1 | |
| 10603656 | 2 | |
| 11040774 | 1 | |
| 11869546 | 1 |
| Value | Count | Frequency (%) |
| 50788652 | 1 | |
| 50788626 | 1 | |
| 40147674 | 1 | |
| 40147618 | 1 | |
| 31047780 | 1 | |
| 26446178 | 1 | |
| 26399133 | 1 | |
| 23212268 | 1 | |
| 20483444 | 1 | |
| 20327883 | 1 |
Licensed
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 KiB |
| True | |
|---|---|
| False | 4 |
| Value | Count | Frequency (%) |
| True | 46 | |
| False | 4 | 8.0% |
Stream
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2324983 × 109 |
| Minimum | 22632716 |
|---|---|
| Maximum | 3.3620052 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 22632716 |
|---|---|
| 5-th percentile | 69704253 |
| Q1 | 8.0295127 × 108 |
| median | 1.3797651 × 109 |
| Q3 | 1.6758385 × 109 |
| 95-th percentile | 2.2414298 × 109 |
| Maximum | 3.3620052 × 109 |
| Range | 3.3393725 × 109 |
| Interquartile range (IQR) | 8.7288722 × 108 |
Descriptive statistics
| Standard deviation | 6.8110617 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.55262238 |
| Kurtosis | 0.86929116 |
| Mean | 1.2324983 × 109 |
| Median Absolute Deviation (MAD) | 3.3330558 × 108 |
| Skewness | 0.19111968 |
| Sum | 6.1624917 × 1010 |
| Variance | 4.6390562 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 1379765140 | 3 | 6.0% |
| 1506598267 | 2 | 4.0% |
| 1389243583 | 2 | 4.0% |
| 1521254554 | 2 | 4.0% |
| 1713070715 | 2 | 4.0% |
| 1048932845 | 2 | 4.0% |
| 1807370674 | 1 | 2.0% |
| 859799057 | 1 | 2.0% |
| 1312649614 | 1 | 2.0% |
| 1270912565 | 1 | 2.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 22632716 | 1 | |
| 46554351 | 1 | |
| 58470533 | 1 | |
| 83434355 | 1 | |
| 96075345 | 1 | |
| 135121858 | 1 | |
| 268969064 | 1 | |
| 370991124 | 1 | |
| 625188054 | 1 | |
| 629918488 | 1 |
| Value | Count | Frequency (%) |
| 3362005201 | 1 | |
| 2369272335 | 1 | |
| 2312689776 | 1 | |
| 2154334378 | 1 | |
| 1833638048 | 1 | |
| 1807370674 | 1 | |
| 1805319715 | 1 | |
| 1785368454 | 1 | |
| 1740759086 | 1 | |
| 1713070715 | 2 |
| Unnamed: 0 | Danceability | Energy | Key | Loudness | Speechiness | Acousticness | Instrumentalness | Liveness | Valence | Tempo | Duration_ms | Views | Likes | Stream | Artist | Track | Title | Channel | Licensed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unnamed: 0 | 1.000 | 0.142 | -0.300 | 0.061 | -0.233 | -0.050 | -0.010 | 0.276 | 0.143 | -0.126 | 0.038 | -0.377 | -0.250 | -0.150 | -0.015 | 0.512 | 0.210 | 0.257 | 0.483 | 0.126 |
| Danceability | 0.142 | 1.000 | 0.025 | 0.089 | 0.036 | 0.292 | 0.017 | 0.176 | -0.113 | 0.473 | 0.006 | -0.062 | -0.175 | -0.074 | -0.173 | 0.000 | 0.457 | 0.397 | 0.374 | 0.000 |
| Energy | -0.300 | 0.025 | 1.000 | 0.209 | 0.745 | 0.266 | -0.361 | 0.094 | 0.051 | 0.240 | -0.056 | -0.210 | -0.340 | -0.079 | -0.104 | 0.000 | 0.403 | 0.301 | 0.278 | 0.000 |
| Key | 0.061 | 0.089 | 0.209 | 1.000 | 0.177 | 0.161 | -0.020 | 0.052 | 0.093 | -0.066 | -0.084 | -0.170 | -0.317 | -0.025 | -0.074 | 0.000 | 0.431 | 0.405 | 0.364 | 0.000 |
| Loudness | -0.233 | 0.036 | 0.745 | 0.177 | 1.000 | 0.075 | -0.231 | 0.271 | 0.115 | 0.106 | -0.117 | -0.150 | -0.358 | -0.209 | 0.038 | 0.000 | 0.403 | 0.305 | 0.000 | 0.287 |
| Speechiness | -0.050 | 0.292 | 0.266 | 0.161 | 0.075 | 1.000 | -0.086 | -0.097 | -0.421 | 0.177 | -0.056 | -0.218 | -0.126 | 0.376 | 0.046 | 0.296 | 0.403 | 0.425 | 0.528 | 0.457 |
| Acousticness | -0.010 | 0.017 | -0.361 | -0.020 | -0.231 | -0.086 | 1.000 | -0.321 | -0.005 | 0.048 | -0.105 | 0.419 | -0.013 | -0.231 | -0.138 | 0.000 | 0.431 | 0.329 | 0.213 | 0.000 |
| Instrumentalness | 0.276 | 0.176 | 0.094 | 0.052 | 0.271 | -0.097 | -0.321 | 1.000 | 0.006 | -0.025 | 0.089 | -0.414 | -0.209 | -0.256 | -0.055 | 0.479 | 0.354 | 0.408 | 0.559 | 0.000 |
| Liveness | 0.143 | -0.113 | 0.051 | 0.093 | 0.115 | -0.421 | -0.005 | 0.006 | 1.000 | -0.165 | -0.054 | -0.010 | 0.011 | -0.303 | -0.040 | 0.000 | 0.369 | 0.426 | 0.372 | 0.461 |
| Valence | -0.126 | 0.473 | 0.240 | -0.066 | 0.106 | 0.177 | 0.048 | -0.025 | -0.165 | 1.000 | 0.279 | -0.112 | 0.051 | -0.227 | -0.295 | 0.000 | 0.457 | 0.469 | 0.431 | 0.145 |
| Tempo | 0.038 | 0.006 | -0.056 | -0.084 | -0.117 | -0.056 | -0.105 | 0.089 | -0.054 | 0.279 | 1.000 | -0.314 | 0.150 | 0.031 | -0.139 | 0.088 | 0.431 | 0.347 | 0.384 | 0.000 |
| Duration_ms | -0.377 | -0.062 | -0.210 | -0.170 | -0.150 | -0.218 | 0.419 | -0.414 | -0.010 | -0.112 | -0.314 | 1.000 | 0.162 | 0.005 | 0.006 | 0.114 | 0.365 | 0.370 | 0.357 | 0.000 |
| Views | -0.250 | -0.175 | -0.340 | -0.317 | -0.358 | -0.126 | -0.013 | -0.209 | 0.011 | 0.051 | 0.150 | 0.162 | 1.000 | 0.516 | 0.185 | 0.000 | 0.369 | 0.426 | 0.334 | 0.000 |
| Likes | -0.150 | -0.074 | -0.079 | -0.025 | -0.209 | 0.376 | -0.231 | -0.256 | -0.303 | -0.227 | 0.031 | 0.005 | 0.516 | 1.000 | 0.498 | 0.000 | 0.403 | 0.436 | 0.393 | 0.076 |
| Stream | -0.015 | -0.173 | -0.104 | -0.074 | 0.038 | 0.046 | -0.138 | -0.055 | -0.040 | -0.295 | -0.139 | 0.006 | 0.185 | 0.498 | 1.000 | 0.000 | 0.431 | 0.418 | 0.323 | 0.000 |
| Artist | 0.512 | 0.000 | 0.000 | 0.000 | 0.000 | 0.296 | 0.000 | 0.479 | 0.000 | 0.000 | 0.088 | 0.114 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.207 | 0.819 | 0.000 |
| Track | 0.210 | 0.457 | 0.403 | 0.431 | 0.403 | 0.403 | 0.431 | 0.354 | 0.369 | 0.457 | 0.431 | 0.365 | 0.369 | 0.403 | 0.431 | 0.000 | 1.000 | 0.976 | 0.889 | 0.354 |
| Title | 0.257 | 0.397 | 0.301 | 0.405 | 0.305 | 0.425 | 0.329 | 0.408 | 0.426 | 0.469 | 0.347 | 0.370 | 0.426 | 0.436 | 0.418 | 0.207 | 0.976 | 1.000 | 0.911 | 0.408 |
| Channel | 0.483 | 0.374 | 0.278 | 0.364 | 0.000 | 0.528 | 0.213 | 0.559 | 0.372 | 0.431 | 0.384 | 0.357 | 0.334 | 0.393 | 0.323 | 0.819 | 0.889 | 0.911 | 1.000 | 0.559 |
| Licensed | 0.126 | 0.000 | 0.000 | 0.000 | 0.287 | 0.457 | 0.000 | 0.000 | 0.461 | 0.145 | 0.000 | 0.000 | 0.000 | 0.076 | 0.000 | 0.000 | 0.354 | 0.408 | 0.559 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Unnamed: 0 | Artist | Track | Danceability | Energy | Key | Loudness | Speechiness | Acousticness | Instrumentalness | Liveness | Valence | Tempo | Duration_ms | Title | Channel | Views | Likes | Licensed | Stream | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1063 | 1147 | Luis Fonsi | Despacito | 0.655 | 0.797 | 2.0 | -4.787 | 0.1530 | 0.19800 | 0.000000 | 0.0670 | 0.839 | 177.928 | 229360.0 | Luis Fonsi - Despacito ft. Daddy Yankee | LuisFonsiVEVO | 8.079649e+09 | 50788652.0 | True | 1.506598e+09 |
| 356 | 365 | Daddy Yankee | Despacito | 0.655 | 0.797 | 2.0 | -4.787 | 0.1530 | 0.19800 | 0.000000 | 0.0670 | 0.839 | 177.928 | 229360.0 | Luis Fonsi - Despacito ft. Daddy Yankee | LuisFonsiVEVO | 8.079647e+09 | 50788626.0 | True | 1.506598e+09 |
| 11708 | 12452 | Ed Sheeran | Shape of You | 0.825 | 0.652 | 1.0 | -3.183 | 0.0802 | 0.58100 | 0.000000 | 0.0931 | 0.931 | 95.977 | 233713.0 | Ed Sheeran - Shape of You (Official Music Video) | Ed Sheeran | 5.908398e+09 | 31047780.0 | True | 3.362005e+09 |
| 13709 | 14580 | Charlie Puth | See You Again (feat. Charlie Puth) | 0.689 | 0.481 | 10.0 | -7.503 | 0.0815 | 0.36900 | 0.000001 | 0.0649 | 0.283 | 80.025 | 229526.0 | Wiz Khalifa - See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack | Wiz Khalifa Music | 5.773798e+09 | 40147674.0 | True | 1.521255e+09 |
| 11725 | 12469 | Wiz Khalifa | See You Again (feat. Charlie Puth) | 0.689 | 0.481 | 10.0 | -7.503 | 0.0815 | 0.36900 | 0.000001 | 0.0649 | 0.283 | 80.025 | 229526.0 | Wiz Khalifa - See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack | Wiz Khalifa Music | 5.773797e+09 | 40147618.0 | True | 1.521255e+09 |
| 19254 | 20303 | CoComelon | Wheels on the Bus | 0.941 | 0.387 | 9.0 | -11.920 | 0.0427 | 0.18400 | 0.000029 | 0.1570 | 0.965 | 125.021 | 207340.0 | Wheels on the Bus | CoComelon Nursery Rhymes & Kids Songs | Cocomelon - Nursery Rhymes | 4.898831e+09 | 14396841.0 | True | 8.343436e+07 |
| 10047 | 10686 | Mark Ronson | Uptown Funk (feat. Bruno Mars) | 0.856 | 0.609 | 0.0 | -7.223 | 0.0824 | 0.00801 | 0.000082 | 0.0344 | 0.928 | 114.988 | 269667.0 | Mark Ronson - Uptown Funk (Official Video) ft. Bruno Mars | MarkRonsonVEVO | 4.821016e+09 | 20067879.0 | True | 1.653820e+09 |
| 8397 | 8937 | PSY | Gangnam Style (강남스타일) | 0.727 | 0.937 | 11.0 | -2.871 | 0.2860 | 0.00417 | 0.000000 | 0.0910 | 0.749 | 132.067 | 219493.0 | PSY - GANGNAM STYLE(강남스타일) M/V | officialpsy | 4.679767e+09 | 26399133.0 | False | 3.709911e+08 |
| 8989 | 9569 | Maroon 5 | Sugar | 0.748 | 0.788 | 1.0 | -7.055 | 0.0334 | 0.05910 | 0.000000 | 0.0863 | 0.884 | 120.076 | 235493.0 | Maroon 5 - Sugar (Official Music Video) | Maroon5VEVO | 3.817733e+09 | 15340646.0 | True | 1.502781e+09 |
| 12239 | 13032 | Katy Perry | Roar | 0.671 | 0.771 | 7.0 | -4.821 | 0.0316 | 0.00492 | 0.000007 | 0.3540 | 0.436 | 90.003 | 223546.0 | Katy Perry - Roar (Official) | KatyPerryVEVO | 3.725749e+09 | 15864499.0 | True | 8.847210e+08 |
| Unnamed: 0 | Artist | Track | Danceability | Energy | Key | Loudness | Speechiness | Acousticness | Instrumentalness | Liveness | Valence | Tempo | Duration_ms | Title | Channel | Views | Likes | Licensed | Stream | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14419 | 15304 | Meghan Trainor | All About That Bass | 0.807 | 0.887 | 9.0 | -3.726 | 0.0503 | 0.0573 | 0.000003 | 0.1240 | 0.961 | 134.052 | 187920.0 | Meghan Trainor - All About That Bass (Official Video) | MeghanTrainorVEVO | 2.563945e+09 | 9507899.0 | True | 7.029070e+08 |
| 119 | 126 | Eminem | Love The Way You Lie | 0.749 | 0.925 | 10.0 | -5.034 | 0.2270 | 0.2410 | 0.000000 | 0.5200 | 0.641 | 86.989 | 263373.0 | Eminem - Love The Way You Lie ft. Rihanna | EminemVEVO | 2.539157e+09 | 12696568.0 | True | 1.115479e+09 |
| 14660 | 15559 | Natti Natasha | Criminal | 0.814 | 0.813 | 2.0 | -3.023 | 0.0561 | 0.0300 | 0.000093 | 0.2550 | 0.839 | 79.997 | 232550.0 | Natti Natasha ❌ Ozuna - Criminal [Official Video] | NATTI NATASHA | 2.447960e+09 | 8195497.0 | True | 7.840020e+08 |
| 15695 | 16637 | Ozuna | Taki Taki (with Selena Gomez, Ozuna & Cardi B) | 0.842 | 0.801 | 8.0 | -4.167 | 0.2280 | 0.1570 | 0.000005 | 0.0642 | 0.617 | 95.881 | 212500.0 | DJ Snake - Taki Taki ft. Selena Gomez, Ozuna, Cardi B (Official Music Video) | DJSnakeVEVO | 2.414202e+09 | 18776043.0 | True | 1.379765e+09 |
| 14504 | 15389 | DJ Snake | Taki Taki (feat. Selena Gomez, Ozuna & Cardi B) | 0.842 | 0.801 | 8.0 | -4.167 | 0.2280 | 0.1570 | 0.000005 | 0.0642 | 0.617 | 95.881 | 212500.0 | DJ Snake - Taki Taki ft. Selena Gomez, Ozuna, Cardi B (Official Music Video) | DJSnakeVEVO | 2.414202e+09 | 18776025.0 | True | 1.379765e+09 |
| 12706 | 13526 | Selena Gomez | Taki Taki (with Selena Gomez, Ozuna & Cardi B) | 0.842 | 0.801 | 8.0 | -4.167 | 0.2280 | 0.1570 | 0.000005 | 0.0642 | 0.617 | 95.881 | 212500.0 | DJ Snake - Taki Taki ft. Selena Gomez, Ozuna, Cardi B (Official Music Video) | DJSnakeVEVO | 2.414201e+09 | 18776010.0 | True | 1.379765e+09 |
| 13195 | 14030 | Imagine Dragons | Believer | 0.776 | 0.780 | 10.0 | -4.374 | 0.1280 | 0.0622 | 0.000000 | 0.0810 | 0.666 | 124.949 | 204347.0 | Imagine Dragons - Believer (Official Music Video) | ImagineDragonsVEVO | 2.369715e+09 | 20483444.0 | True | 2.369272e+09 |
| 14565 | 15463 | Darell | Te Boté | 0.918 | 0.602 | 4.0 | -3.986 | 0.1150 | 0.4010 | 0.000007 | 0.0805 | 0.158 | 96.518 | 275693.0 | Casper, Nio García, Darell, Nicky Jam, Bad Bunny, Ozuna - Te Bote Remix (Video Oficial) | Flow La Movie | 2.354418e+09 | 10169573.0 | True | 9.607534e+07 |
| 16332 | 17286 | Shawn Mendes | Treat You Better | 0.444 | 0.819 | 10.0 | -4.078 | 0.3410 | 0.1060 | 0.000000 | 0.1070 | 0.747 | 82.695 | 187973.0 | Shawn Mendes - Treat You Better | ShawnMendesVEVO | 2.315954e+09 | 11040774.0 | True | 1.697308e+09 |
| 13317 | 14152 | Ellie Goulding | Love Me Like You Do | 0.489 | 0.597 | 5.0 | -6.633 | 0.0292 | 0.2700 | 0.000000 | 0.1050 | 0.324 | 95.012 | 253520.0 | Ellie Goulding - Love Me Like You Do (Official Video) | EllieGouldingVEVO | 2.283748e+09 | 12418131.0 | True | 2.689691e+08 |